1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to
MySql: www.mysql.org
First, start and stop the mysql Service
Net stop mysql
Net start mysql
Second, log on to mysql
Mysql-u user name-p User Password
Mysql-uroot-p. After you press enter, you are prompted to enter the password, enter 12345,
MySQL command line, you can modify the MySQL database password, the following for you to detail the MySQL command line, if you are interested, may wish to see.
Format: Mysqladmin-u username-P Old password password new password
1, to root add a
1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to
One, log in to the MySQL database server from the command line
1. Log in with MySQL using the default 3306 port
/usr/local/mysql/bin/mysql-u root-p
2. Manage multiple MySQL on different ports via TCP connection (note: This feature is only available
The latest version of MySQL is 5.7.11, which provides a specific distribution installation package (such as. rpm) and a binary generic installation package (. tar.gz) under Linux. In general, many projects tend to adopt a binary common installation
This article mainly introduces someMySQL databaseOfCommand LineSome Common commands, including starting and stopping services, user logon, user management, and use of commonly used batch processing commands. Let's take a look at them.
Start and Stop
Issue: Command line login mysql prompt ' MySQL ' is not an internal or external command. As shown in 1.Figure 1Cause: The MySQL Bin folder is not configured in the environment variable area because the command line login MySQL needs to call the
View the character set mysqlshowcharacterset supported by the current mysql database; view the character set of the current database: mysqlshowvariableslike % char %; 1. Connect to MYSQL: mysql-h host address-u user name-p user password or: mysql-u
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.